Importing Accounts Receivable Transactions

Transactions that do not go through the normal invoice and billing process can be imported into Accounts Receivable. You can also use an accounts receivable import to add beginning balances. Using transaction imports can reduce the amount of manual data entry that your team must perform.

You can import Information for the following types of transactions:

Payments

Credit adjustments

Credit memos

Debit adjustments

Debit memos

Miscellaneous charges

Tax Write-offs

Write-offs

Imported payments are distributed to invoices automatically, but are not posted. Your firm's staff must review and post the imported transactions. Other types of imported transactions are not distributed automatically.

Note: Imported payments will display "Import" in the Payment Method column of the Accounts Receivable transactions grid. Other imported transaction types will not display "Import" in this column.

Preparing for the Import

The transaction information that you want to import should be in a CSV file or a Microsoft® Excel® spreadsheet. The columns that must be in your import document vary depending on the type of transaction you are importing. For information about creating your AR import file, see Preparing Your Accounts Receivable Import File.

Note: The AR Import is limited to 1000 transactions per import.

Performing the Import

To import accounts receivable transactions, do the following:

  1. Create your import spreadsheet following the directions in Preparing Your Accounts Receivable Import File.
  2. Open ClosedAccounts Receivable.
    1. In Dashboard, click Application Links on the navigation panel.
    2. Under Accounts Receivable, click AR transactions.
  3. In the Transactions grid at the bottom of the window, click Import.
  4. In the Entry Type list, select the type of transaction you want to import.
  5. If you are importing a payment, select the bank account where the payments were deposited.
  6. Either click to select the source file to import, or drag and drop the file to the box.
  7. Click Import.

    Note: Depending on the number of transactions, the import could take some time. You will receive an email notification with detailed information about which transactions were successfully imported and any that could not be imported.

  8. If you have additional imports to perform, click Import Another File. Otherwise, click Close.

You are now ready to edit or post the transactions as needed.